LOAD DATA
TRUNCATE 
INTO TABLE gex_bde_gl_act_d_tb
TRAILING NULLCOLS 
(line_no                	SEQUENCE(MAX)
,date_prod			POSITION(1:11)		"TO_DATE(:date_prod,'YYYY/MM/DD')"                      
,cd_portef			POSITION(12:27)		CHAR 
,cd_division			POSITION(28:39) 	CHAR
,cd_direction			POSITION(40:52) 	CHAR    
,cd_activite			POSITION(53:64)		CHAR
,cd_mode_gestion 		POSITION(65:80) 	CHAR
,cd_classe_actif		POSITION(81:96)		CHAR
,id_titre			POSITION(97:108)	"TRIM(:id_titre)"
,cd_titre			POSITION(109:124)	CHAR
,cd_devise			POSITION(125:140)	CHAR
,contributions_dev_local	POSITION(141:164)	"TO_NUMBER(:contributions_dev_local,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,contributions_dev_cad		POSITION(165:187)	"TO_NUMBER(:contributions_dev_cad,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,contributions_dev_usd		POSITION(187:208)	"TO_NUMBER(:contributions_dev_usd,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,provenance 			POSITION(209:218)	CHAR
)                                                                                                      
